This code will help produce the three visuals that are going to be a
part of each equity tracker indicator webpage: regional map (tract
level) of most recent data, chart of the most recent data, chart of
trends over time.
If the indicator is available through a tract-level data
set. Getting the data to a workable version may require some
data transformation. To explore, clean, transform, and generate a final
data set, please use the data-gen-tract-template. This script
will generate an .rda for the map and an .rda for the charts. These data
sets will be loaded in before the data visualization code.
Traffic related deaths and serious injuries per 100,000 by census tract. Understanding where traffic related deaths and serious injuries occur at a higher rate can help us understand which communities are disproportionately impacted.
To map data in this form, there should be a value corresponding to each census tract. Depending on the year or source of the data, this could be about 700 rows for data at the 2010 census tract resolution, or about 900 rows for data at the 2020 census tract resolution.
The map scale has been adjusted to the natural log of the rate to make the map colors meaningful.
Sources: Washington Traffic Safety Commission; U.S. Census Bureau, Geography Division 2020 TIGER/Line Shapefiles
Traffic Related Deaths and Serious Injuries per 100,000
Census Tract Level
Washington Traffic Safety Commission U.S. Census Bureau, American Community Survey (ACS) 2020 5-Year Public Use Microdata Sample (PUMS)
As a region:
2.75x: Communities with high concentrations of households with lower income are 2.75 times more likely to have a collision with a death or serious injury occur in their community
2.25x: Communities with high concentrations of people with a disability are 2.25 times more likely to have these collisions
1.5x: Communities with high concentrations of households with
limited English proficiency are 1.5 times more likely to have these
collisions
Traffic Related Deaths and Serious Injuries per 100,000
Census Tract Level
Washington Traffic Safety Commission U.S. Census Bureau, American Community Survey (ACS) 2020 5-Year Public Use Microdata Sample (PUMS)
As a region:
1.5x: In 2016, communities with low and high concentrations of households with limited English proficiency had nearly the same rate of collisions with a death or serious injury but by 2021 - the gap had increased by 1.5 times
50%: The gap increased 50% between communities with low and high concentrations of people with a disability between 2012 and 2021
25% larger gap: The gap increased 25% between communities with low and high concentrations of households with lower income between 2010 and 2021